SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and (bedrooms='3') and (bedrooms='3')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Welcome to 60 Church Street, a spacious and well-maintained home located in the heart of Lebanon, New Hampshire. Situated on a quiet street just steps from downtown amenities, this property offers an ideal combination of comfort, convenience, and flexibility for a variety of living arrangements. The home features generously sized bedrooms, providing ample space for residents, guests, or home office setups. Thoughtful storage solutions can be found throughout the property, a rare and highly desirable feature that helps keep living spaces organized and functional. From closets and built-ins to additional storage areas, there is room for everything without sacrificing living space. Gorgeous hardwood floors throughout and a quaint yard with deck. One of the property's standout advantages is its location. Downtown Lebanon's restaurants, shops, parks, and community amenities are all within easy reach, while major commuter routes provide convenient access throughout the Upper Valley region. The home is also located just a short drive from Dartmouth Hitchcock Medical Center. Whether used as a primary residence, a long-term rental property, or a home with room-rental potential, 60 Church Street offers exceptional versatility. The layout provides privacy and comfort, while the home's size and storage capacity make it practical for multiple occupants. Minutes from downtown and great views of Storrs Hill historic Erling Heistad 50-meter ski jump, one of New England's most recognized community ski-jumping venues. Great location, great price!
Description:Summers spent on sandy beaches are a must with how close this home is to North Cove Beach of Eastman Lake. Outdoor features include a nice level lot with mature landscaping and an updated roof, while inside features an updated kitchen and appliances, propane stoves in the living and family rooms, and a large sun-filled room for year-round enjoyment. This 3-bedroom, 2-bath home has a split-level entry with all bedrooms on the main level and a spacious family room on the lower level. Eastman offers exceptional amenities, including lake activities, a championship golf course, tennis, pickleball, groomed cross-country ski trails, miles of walking and hiking trails, an indoor pool, exercise facility and more! Conveniently located just minutes from the Upper Valley and Lake Sunapee regions and only two hours from Boston. Eastman provides a chance to connect with nature through seasonal recreation and connect with people through welcoming community activities.
Description:Privately situated on 6 peaceful acres near Crystal Lake, this spacious Ranch offers the perfect blend of comfort, privacy, and versatility with a separate in-law/accessory apartment. The open-concept main living area features gorgeous hardwood floors and a seamless flow from the kitchen to the dining area and expansive living room. Step outside to the impressive 40' x 12' deck overlooking the private backyard—an ideal setting for entertaining or relaxing while enjoying the natural surroundings. The oversized living room is anchored by a cozy wood stove with a classic brick chimney, providing warmth and ambiance during the colder months. Down the hall, you'll find the main full bath and three bedrooms, including a spacious primary suite with a recently updated tiled bath. The accessory apartment offers excellent flexibility for extended family, guests, or potential rental income. It was rented for $1,750 per month! It features an open-concept kitchen and living area, a full bath, and a loft bedroom with closet space as well as access to the attic for additional storage. The walkout lower level offers endless possibilities for future expansion, with plenty of room for a family room, gym or workshop. The public boat launch is close by with plenty of parking space for your truck & trailer while you enjoy all that Crystal Lake has to offer; fishing, boating, kayaking and swimming at the sand bar. Enjoy snowmobiling, hiking and bike riding throughout the nearby trails.
Description:Welcome to 21 Wheatley Street, a 3-bedroom ranch nestled in the heart of Lebanon, NH. This versatile home offers comfortable one-level living, fully finished lower level living space, and the option for rental income or private guest space above the garage. Both the main home and the above-garage living space feature sun-lit enclosed porches, creating inviting areas to relax year-round. The property includes a large two-car garage and a spacious storage shed, providing excellent space for vehicles, tools, and outdoor equipment. The main home also features a lovely deck and ample outdoor space—perfect for entertaining, gardening, or simply enjoying the seasons. Ideally situated near Lebanon’s vibrant downtown, local shops and restaurants, excellent schools, community events, Dartmouth-Hitchcock Medical Center, Dartmouth College, and major commuting routes. Outdoor enthusiasts will appreciate easy access to nearby trails, parks, and recreation. Whether you’re seeking a flexible primary residence or an income-producing opportunity, this property combines functionality, storage, and the best of Lebanon living. Tenant-occupied.
Description:Welcome to this beautifully updated 3-bedroom + office, 1-bathroom historic gem nestled in a prime Lebanon location! Just a short stroll to the vibrant Lebanon Green, steps from the scenic Rail Trail, and only 5 miles from Dartmouth College and Dartmouth Health, this home offers the perfect blend of classic character and modern convenience. Spanning approximately 2156 square feet, this residence exudes timeless charm with newly refinished hardwood floors, fresh paint throughout, and new windows and siding. Upstairs, you'll find three generously sized bedrooms filled with natural light. The main floor features a spacious living room, an inviting dining area, a stylishly renovated full bathroom, a versatile office or guest room, and a modern new kitchen. The kitchen is complete with stainless steel appliances, warm wood countertops, and a farmhouse sink. Additional highlights include a new washer and dryer, an attached one-car garage, and a spacious 600 sq. ft. unfinished bonus room above the garage, ideal for future expansion, a studio, workshop, or extra storage. Set on a recently landscaped lot with mature flowering plants and ample parking, this property combines historic New England charm with thoughtful modern updates in one of Lebanon’s most convenient and walkable neighborhoods.